Thread: Formula that works like text-to-column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Formula that works like text-to-column
You could use a combination of LEFT, MID and RIGHT functions, for
example if your text is in A1, then:

B1: =LEFT(A1,3)
C1: =MID(A1,6,3)
D1: =MID(A1,11,3)
E1: =RIGHT(A1,3)

These can then be copied down the columns.

Hope this helps.

Pete

On Mar 8, 12:45 pm, linglc wrote:
I have a cell that looks like this "123, 456, 789, 234". Is there a formula
that I can use that to seperate them instead of doing text-to-column?


Reply With QuoteReply With Quote