How to do this in excel.

A

Adapter

Newbie

Jan 3, 2012

12

2

• Jan 5, 2012

• #1

Hello,

I have list in excel in column A, I want to remove everything before a character.

For example, I have list like this -

hello1 hello2 hello3 $ hello4
hello1 $ hello2 hello3 hello4

now, if I choose $ as the character and I run it, it should become -

hello4
hello2 hello3 hello4

Anyone knows how to do this in excel ?

Thanks

 

Knoxgates

Supreme Member

Aug 9, 2008

1,265

927

• Jan 5, 2012

• #2

Which version you are using office 2003 or office 2007
Use text to column feature in msoffice.

 

G-S-T

Elite Member

Jan 20, 2011

1,762

9,092

• Jan 5, 2012

• #3

copy the column into a separate file. then import it back into your document, choose from the paste options to separate by $ instead of ,

 

meatro

BANNED

Nov 21, 2009

568

1,001

• Jan 5, 2012

• #4

Not sure if you're able to do something like this in Excel without writing code.

Regular Expressions could do it very easily, though. Go get something like Expresso (free) and use RegEx to remove everything after the $ character.

It'd be something like this:

Code:

(=$).*

 

S

smarttips

Junior Member

Oct 31, 2011

145

16

• Jan 5, 2012

• #5

Select the whole column containing data...Just click data tab ----> Text to columns(in data tools part) ---->choose delimited and click next ----->Select "other" check box and put your character in the box and click next---> it will break your data in two columns..one of these columns will contain your result.
(All these steps are based on excel 2007)