HELP ME PLEASEEE- how to format data in a column

R

Riza

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.
 
G

Guest

Hi

Use a blank column with the formula:
="ab"&A2
where A2 contains your number.
Once you have filled this down the column, select them all and Ctrl+C
(Copy). Then select Edit/Paste Special/Values to fix the values in place.

Hope this helps.
Andy.
 
B

BekkiM

One way is to insert a column and use the following formula:

=concatenate("ab",A1)

[assuming Column A contains your original number]
 
P

pinmaster

Try this:

Use or insert a blank column somewhere then type:

="AB"&A1
copy down as far as needed, then copy the column and paste over the original
column (Paste Special - Values) then delete the helper column.

Note: it's always a good idea to save your data before trying anything new.

HTH
JG
 
S

SVC

If cell A1 contains 123, in cell B1 type ="ab"&A1. Copy down the entire
column. Then select column B, do a Copy and then Paste Special, Value.
 
S

sam

Assuming all the numbers are in Col A, and are on consecutive rows, in Col B
write =â€abâ€&A1. Then highlite your whole Col B range, copy, paste special
values. Move it to Col A and you’re done.
 
E

exceluserforeman

Say A2 is the start of the column of data


Put this routine in a Module in VB Editor (Tools > Macro > Vb Editor )
Toolbar >insert > Module

Module1 shows in the projects window

copy and paste this macro into it



Close the vBeditor then
On the sheet toolbar Run macro


Sub AddABToData()
Dim strcell, strAB as string
strAB="AB"
range("A2") .select
set a=selection
'aSSUMES THERE IS MORE THAN ONE FILLED CELL
range(a,a.end(xldown)).select
for each cell in selection
if cell.value<>"" then
strCell=strAB & cell.value
cell.value=strCell
end if
next

end sub

- -mark
 
W

will A

Wow, Riza, This is the first time I saw a lot of responses from the community
with almost the same solutions. I envy you.
 
Top