Removing leading text characters

[Scott]

Hello,

Can someone tell me how I can remove leading characters
from within a cell. I can't use the RIGHT function
because the number of characters within the cells varies.

Example: I'd like to extract company names to column B so
that the range B1:B3 would read Sears,Microsoft,Google
without the regions.

Range A1:A3
Southwest Sears
North Microsoft
West Google

Thanks in advance for your help.

 

[Frank Kabel]

Hi
try
=TRIM(MID(A1,FIND(" ",A1)+1,255))

 

[Biff]

Hi Scott!

Use the Text to Columns command in the Data menu. Use the
delimited option and check the space box. Then you can
just delete column A.

Biff