Function to Replace _ with a Space

greenlight

New Member
Joined
May 8, 2009
Messages
14
hello everyone, new user to the forums. tried looking this up but couldn't quite find it. i'm using a mac and running excel 2008 and trying to take the underscore out and replace it with a space so from:

ibm_us

to:

ibm us

i've looked and some people said you could just leave the replace field empty but i get an error that says excel can't find anything that matches. any idea on this? doesn't matter if it's a function or a find/replace. in fact, i would prefer that it was a function so i can just fill down. thanks. sorry if this is basic, but i definitely tried looking!
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
hello everyone, new user to the forums. tried looking this up but couldn't quite find it. i'm using a mac and running excel 2008 and trying to take the underscore out and replace it with a space so from:

ibm_us

to:

ibm us

i've looked and some people said you could just leave the replace field empty but i get an error that says excel can't find anything that matches. any idea on this? doesn't matter if it's a function or a find/replace. in fact, i would prefer that it was a function so i can just fill down. thanks. sorry if this is basic, but i definitely tried looking!
Hi greenlight:

Welcome to MrExcel Board!

The following approach will do what you want without using any formula ...

Let us say I start off with the entry ibm_us in cell A5 ... then

1) select cell A5
2) do EDIT|REPLACE and in
Find what: Textbox key-in _ and in
Replace with: Text box key-in a space character
3) click on Replace Button

and you will see the result in cell A5 as shown in the following ...
<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
A
1ibm_us
2*
3to:
4*
5ibm us
Sheet2


</body></html>

I hope this helps.
 

greenlight

New Member
Joined
May 8, 2009
Messages
14
Wow I really thought I tried that the first time and it didn't work. Thanks so much! Have a good one.
 

Forum statistics

Threads
1,085,995
Messages
5,387,148
Members
402,045
Latest member
Hidalgo

Some videos you may like

This Week's Hot Topics

Top