View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Splitting Information in a Cell

Is it always 5 characters followed by 2?

Data|Text to columns
or
you can use formulas
=left(a1,5)
=right(a1,2)



Mad Dog wrote:

How would I take this value in a single cell:

12345AB

and create this value in two cells, as follows:

12345 AB

Thanking you in advance!

Mad Dog


--

Dave Peterson