• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Assistance reformatting text in a cell

W

wlerner

New Member
I have multiple rows of text that are mostly two word entries. For example, some of the entries are:


Blue House

Red House

Green House


I need to reformat the text for another application so that each entry appears with an underscore between the words. For example:


Blue_House

Red_House

Green_House


Any suggestions from the awesome folks here is appreciated! Thanks as always.
 
Dear wlerner

Hui's solution is very simple, just Ctrl+H and replace


You can try by formula

Col-A Col-B Col-C

Blue House =A2&"_"&B2

Red House

Green House


Write the formula and copy down

--Muneer
 
Hi,


You can also try the below formula if all your text in column A

Col A = Text Col B =Forumla Col


Blue House =SUBSTITUTE(A1," ","_",1) [output=Blue_House]

Red House =SUBSTITUTE(A2," ","_",1) [output=Red_House]

Green House =SUBSTITUTE(A3," ","_",1) [output=Green_House]


Thanks,

Suresh Kumar S
 
Thank you all! I can't believe I missed the "Find and Select" icon on the tool bar! Once again, the Excel masters have spoken!
 
You must log in or register to reply here.
Back
Top