Copy cell data to 2 cells

  • Thread starter Thread starter Johnnyb
  • Start date Start date
J

Johnnyb

I have a cell with code & company name, e.g "JB123/JOE BLOGGS LTD" can
break up this information into 2 new cells using a formula for each.

Regard's,

Johnnyb
 
I read in microsoft.public.excel.worksheet.functions that Johnnyb
I have a cell with code & company name, e.g "JB123/JOE BLOGGS LTD" can i
break up this information into 2 new cells using a formula for each.
Click to expand...
If the data is in Text format, you can add two new columns to the right
of your present one and use Tools > Text to columns, with delimiter / to
put the code and the name into separate columns. Then you can process
each column as you wish.
 
Hi
try
=TRIM(LEFT(A1,FIND("/",A1)-1))

and
=TRIM(MID(A1,FIND("/",A1)+1,255)

or use 'Data - Text to columns' for this
 
Back
Top