Adding same text to multiple cells

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
Hi

I need some help to add same text to multiple cells which already contains data spread over my worksheet at one time. Adding it one by one is not a good option.

eg. I have cells with values 213, 423, 323, 205 and want to add "T" at the end of all the values in the same cell.

How do I do it?

Your help is appreciated

Thanks and regards
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
Hi Erik

Yes, I know about FIND+REPLACE, the problem is that some of the cells containing 213 has not to be changed or added with T. I need to select the cells and than add the required text.

Sorry I did not mention this in my previous message

Thanks and Regards
Kshora
 

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
Can someone help me out with my problem as mentioned in my previous message

Thanks and Regards

KShora
 

Claymationator

Well-known Member
Joined
Sep 26, 2006
Messages
705

ADVERTISEMENT

I am not sure how this would be done with any code, but if you have an empty column or row that you can copy the data in to there is a really simple way to do it. To show an example I have the following data listed in each of the cells listed:

A1=213
A2=423
A3=323
A4=205
A5=T

Then in cell B1 I have the following formula entered in "=CONCATENATE(A1,$A$5)." From here you just have to drag and copy the formula down the row or column and it will add the "T" to whatever is in the adjacent cell. If you don't want to use that formula you can even enter "=A1&$A$5" and it will give the same results that you can drag and copy.

I am not sure if that will work for you, but hopefully it helps some.
 

rae30

Board Regular
Joined
May 27, 2002
Messages
147

ADVERTISEMENT

&

try this

="T"&A1
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi Erik

Yes, I know about FIND+REPLACE, the problem is that some of the cells containing 213 has not to be changed or added with T. I need to select the cells and than add the required text.

Sorry I did not mention this in my previous message

Thanks and Regards
Kshora
OK,
you want to add a "T" at the end for certain cells
but you didn't tell us when the "T" must be added and when not :confused:

what do you mean with this
I need to select the cells and than add the required text.
are you actually going to "select" them before the operation ??

please provide some examples

best regards,
Erik
 

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
Hi Erik

Thanks a lot for your kind reply, however I did figure out what to do, infact your idea of FIND+REPLACE works very well. Earlier when you did send me the idea, I just went blank and did not think to what to do.

Once again thank you

Regards

KShora
 

Forum statistics

Threads
1,137,199
Messages
5,680,118
Members
419,883
Latest member
overhear

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top