General discussion

Locked

Stripping Text

By karansoin ·
In a column in excel, the cells have text entered as 10/12.5 or12.5/16.
Can a way be found to just have the text after the seperator "/" written into the adjacent cell.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by a.barnes In reply to Stripping Text

Use the FIND and MID functions like this. Assuming the text 10/12.5 is in A2, and you want the result 12.5 in B2, enter the formula below into B2:

=MID(A2,FIND("/",A2)+1,LEN(A2)-FIND("/",A2))

The MID function returns text from A2, from 1 character past the slash character, to the end of the string.

Collapse -

by karansoin In reply to

Great tip. worked for me. Thanks

Collapse -

by DKlippert In reply to Stripping Text

Select the entries. Go to Data>Convert Text to Columns.
When asked for a Delimiter, type / in the Other box.

Collapse -

by karansoin In reply to

This also a good tip. In my case the text is updated frequently. The changes will not automatically update the adjacent columns. Another arrow in the quiver for me! Thanks.

Collapse -

by karansoin In reply to Stripping Text

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums