LinkBack URL
About LinkBacks
Hello,
How do i add text to every cell in a column before or after the text already in the cell? I once had a macro but i forgot how to do it. Any help is much appreciated.
Hello,
How do i add text to every cell in a column before or after the text already in the cell? I once had a macro but i forgot how to do it. Any help is much appreciated.
Hi
select your cells and run this
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
you could use a macro, or just add an additional column and use concatination then paste values over the original.
something like this
="BEFORE-"&A1&"-AFTER"
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
I should have specified. I am horrid with excel. Could you please tell me what to do step by step if possible. =)
which one solution You are interested in?
Whichever gets me able to add text before or after (i need to do both on diff columns) the text already in the cell. I do not know enough about excel to say which would be best.
So maybe start with function:
If you have your text in cell A1, then paste this formula Dgagnon gave You in B1 and see what You get.
I tried:
="<b>Type:</b>"&C1&"<br>"
In cell D2 and it worked, just it was one lower than where i put the information in so it didnt match up with the other columns.
you just need to change it to this:
="<b>Type:</b>"&C2&"<br>"
Got ityay. How do i paste over the old information, keeps saying !REF
Copy whole column and then select your original column -> Right click -> Paste spetial -> Values
Never use Merged Cells in Excel
Last question, how do i add something just to the end of the text in a cell?
just remove the first portion, like this
=C2&"Text After"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks