Removing text

[Rlyeh462]

Hi. I have a column that it populated with "JoeBob.xls". I'm looking for the best way to remove the".xls" from the string so that the final variable returns "JoeBob"

[VBA Noob]

Hi,

Select the column then Data > text to Columns > delimiter > other and enter a .

Then deleted the columns with xls

VBA Noob

[Rlyeh462]

I'm trying to do this in the macro code itself. so that strOne="JoeBob.xls" and strTwo="JoeBob" and I still can use both variables. Ideally, I need to remove the last four charcters from the string.

[ska67can]

Please Login or Register  to view this content.

ska

[VBA Noob]

Prehaps this. Select your range and run

Please Login or Register  to view this content.

VBA Noob

[Rlyeh462]

Thank you very much! This forum is very helpful.

[VBA Noob]

Glad you found a solution

Thx for the feedback

VBA Noob