Copy cell data to 2 cells

[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

 

[John Woodgate]

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.

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.

 

[Frank Kabel]

Hi
try
=TRIM(LEFT(A1,FIND("/",A1)-1))

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

or use 'Data - Text to columns' for this