Formula To Remove Letters

[Dazzawm]

Is there a formula that will take the first 4 letters out of a cell and put them in another i.e

A1 has Good Morning, I want Good left in A1 and Morning put in B1. This just an example and text to columns wont work as there is too much data around the cells.

I dont know if there is a IF/Replace formula or something. Thanks.

 

[pgc01]

Hi

Check the Text to Columns tool.

 

[MrKowz]

Is there a formula that will take the first 4 letters out of a cell and put them in another i.e

A1 has Good Morning, I want Good left in A1 and Morning put in B1. This just an example and text to columns wont work as there is too much data around the cells.

I dont know if there is a IF/Replace formula or something. Thanks.

Just insert a column to the right of the column, and use the Text to Columns tool. That should pose no issue with the amount of "data around the cells".

 

[Dazzawm]

Just insert a column to the right of the column, and use the Text to Columns tool. That should pose no issue with the amount of "data around the cells".

What Listed was an example and within the cells are more like sentences so using text to columns with a space delimiter will split up everything

 

[MrKowz]

What Listed was an example and within the cells are more like sentences so using text to columns with a space delimiter will split up everything

If you need to remove the first four letters, use the fixed-width method instead of delimiter.

 

[Dazzawm]

Thanks I actually sussed that out before you replied. Problem solved. BTW is there no sort of formula to do this then (just to aid my learning).

 

[dcamos]

You could make 2 columns from column A using =left(a1,4) and then =mid(a1,5,25) in the second column.