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
|