Function Help

mrowe · May 21st, 2002, 10:08 AM

Hi,

I need to remove the commas and the text in 3 different collums - can't remember the function to to it.

Dail Express , half by 2 thirds, Colour
Daily Mirror , two by for , Mono
The Observer , half page , Spot

Thanks
Matt

Ricky Morris · May 21st, 2002, 10:41 AM

Try the following substitute function to remove ,.

=SUBSTITUTE(A1,",","")

mrowe · May 21st, 2002, 10:51 AM

after the commas are gone can I spilt the string into 3 different collums?
Matt

PS (thanks for the help on the IF before)

IML · May 21st, 2002, 11:37 AM

Leave the commas in, select text to columns from the dat menu. Step 1 select, delimited and next. Step 2 select comma delimter and clear any other delimiters and hit finish.

There is a formula solution you could use to copy parts to a new column, but it isn't as clean as the text to columns.

May 21st, 2002, 10:41 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try the following substitute function to remove ,. =SUBSTITUTE(A1,",","") __________________ It's never too late to learn something new. Ricky

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

May 21st, 2002, 10:08 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Hi, I need to remove the commas and the text in 3 different collums - can't remember the function to to it. Dail Express , half by 2 thirds, Colour Daily Mirror , two by for , Mono The Observer , half page , Spot Thanks Matt

May 21st, 2002, 10:51 AM	#3
mrowe Board Regular Join Date: Feb 2002 Posts: 232	after the commas are gone can I spilt the string into 3 different collums? Matt PS (thanks for the help on the IF before)

May 21st, 2002, 11:37 AM	#4
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	Leave the commas in, select text to columns from the dat menu. Step 1 select, delimited and next. Step 2 select comma delimter and clear any other delimiters and hit finish. There is a formula solution you could use to copy parts to a new column, but it isn't as clean as the text to columns.