Hello
I have an excel file with 4000 rows and 2 columns. I would like to prepend all the cells in the first column with the text, "Question."
Is there some way to do this without me having to manually add the text to 4000 cells?
Thanks in advance
Hello
I have an excel file with 4000 rows and 2 columns. I would like to prepend all the cells in the first column with the text, "Question."
Is there some way to do this without me having to manually add the text to 4000 cells?
Thanks in advance
Heres 1 method
In a 3rd column enter this formula
="Question. " & A1
fill formula down
copy column with formula
select 1st column
PasteSpecial > Values
Delete column with formula
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Thank you, that worked great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks