Adding A space between an item:

[raffi74]

I would like to add a space between "2236cwestcoast"
I want it to look like "2236 c westcoast"
Is this possible? Ican't seem to find anything in excel. Thanks for your help in advance...
Dave

 

[Aladin Akyurek]

On 2002-03-07 10:48, raffi74 wrote:
I would like to add a space between "2236cwestcoast"
I want it to look like "2236 c westcoast"
Is this possible? Ican't seem to find anything in excel. Thanks for your help in advance...
Dave

Do you have more entries all with the same structure as the example you give ("2236 c westcoast")?

 

[raffi74]

I do have other entries that have the same structure.Also I have other entries with a different structure (with out the "c"
eg..2210westcoast
eg..2210cwestcoast
on the first item I would like to take the left 4 characters.On the second item I would like to take the left 6 charaters after succesfully inserting a space"2210 c westcoast" Thanks again

 

[Mark W.]

=TRIM(REPLACE(SUBSTITUTE(A1,"westcoast"," westcoast"),5,0," "))

where A1 contains your text string.
This message was edited by Mark W. on 2002-03-07 11:16