Adding A space between an item:

raffi74 · Mar 7th, 2002, 11:48 AM

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 · Mar 7th, 2002, 11:57 AM

Quote:

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 · Mar 7th, 2002, 12:07 PM

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. · Mar 7th, 2002, 12:14 PM

=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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 11:48 AM	#1
raffi74 New Member Join Date: Mar 2002 Posts: 8	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

Mar 7th, 2002, 12:07 PM	#3
raffi74 New Member Join Date: Mar 2002 Posts: 8	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

Mar 7th, 2002, 12:14 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=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 ]