Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text To Columns
Hi All: I am having a problem with "Text to Columns". I have a column which includes information which is separated by "/". However, the "/" is not included in every row of the column. i.e. 1 row in the column contains "ADMIN1/232322" and that's easy to make into two columns, however in row 2 I have "232322". This information goes into the left column where "ADMIN1" would be, but I need it to go into the right column where "232322" would be. Is there a way of me getting this information into the correct column? I guess another question I have is maybe I can write an if then statement to add "/" to those cells which don't have them currently so that way I can split the columns up easily. -- Debrap29 ------------------------------------------------------------------------ Debrap29's Profile: http://www.excelforum.com/member.php...o&userid=36127 View this thread: http://www.excelforum.com/showthread...hreadid=559006 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text To Columns
Debrap29, To add the "/" at the beginning when it is not found you could use this. =IF(ISNUMBER(FIND("/",A1,1)),A1,"/"&A1) Copy down as needed. Then copy the result of your formulas and Paste SpecialValues over your new text. Then you can use Text to Columns with the "/" as the delimiter. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=559006 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text To Columns
Debrap29, To add the "/" at the beginning when it is not found you could use this. =IF(ISNUMBER(FIND("/",A1,1)),A1,"/"&A1) Copy down as needed. Then copy the result of your formulas and Paste SpecialValues over your new text. Then you can use Text to Columns with the "/" as the delimiter. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=559006 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text To Columns
Thanks Steve...that worked perfectly!!! -- Debrap29 ------------------------------------------------------------------------ Debrap29's Profile: http://www.excelforum.com/member.php...o&userid=36127 View this thread: http://www.excelforum.com/showthread...hreadid=559006 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text To Columns
You're welcome and thanks for the feedback. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=559006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unwrap text to columns? | Excel Discussion (Misc queries) | |||
Text to columns - one way street? | Excel Discussion (Misc queries) | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) |