Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to somehow separate two sets of data that exist in one cell in Excel?
Please see attached example; the numbers combined in one cell, separated by a slash. I only need the number on the right side of the slash. So in line 4 I want to keep 134 and not include 3 or anything to the left of 3.
Would be awesome if there was a solution for this.
Thanks everyone!
You can use Subfield() function.
Like
Subfield(YourfieldName, '/', 2)
You can use Subfield() function.
Like
Subfield(YourfieldName, '/', 2)
Hi,
I did not clear for which field you are looking for change.
Please check this.
='SubField Out Put :'&SubField(PNPUBA, '/', 2)
Oh sorry the field I was looking to change was "COMMN."
The SubField does seem to work! Thanks!