Thread: Help with replacing items within a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wjohnson
 
Posts: n/a
Default Help with replacing items within a cell

Work with a copy before trying this:
If your data is "equally" spaced - do a select ALL - then convert to
Courier Font - then select the column and then go to the MENU Bar -
DATA - TEXT TO COLUMNS and follow the directions.
You can also use the "MID" FUNCTION - setup the first three cells the
way you want - then copy and paste.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=512879

Reply With QuoteReply With Quote