software

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.

Hi

Use a blank column with the formula:
=quot;abquot;amp;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.

quot;Rizaquot; gt; wrote in message
news
gt;I have like 5000 different data and I need to add letter ab in front of
gt;them.
gt; Could anyone tell me how to do this.
gt;
gt; for example 123 is what it says but I need ab123 and each row is different
gt; number.
One way is to insert a column and use the following formula:

=concatenate(quot;abquot;,A1)

[assuming Column A contains your original number]quot;Rizaquot; wrote:

gt; I have like 5000 different data and I need to add letter ab in front of them.
gt; Could anyone tell me how to do this.
gt;
gt; for example 123 is what it says but I need ab123 and each row is different
gt; number.

Try this:

Use or insert a blank column somewhere then type:

=quot;ABquot;amp;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
quot;Rizaquot; wrote:

gt; I have like 5000 different data and I need to add letter ab in front of them.
gt; Could anyone tell me how to do this.
gt;
gt; for example 123 is what it says but I need ab123 and each row is different
gt; number.

If cell A1 contains 123, in cell B1 type =quot;abquot;amp;A1. Copy down the entire
column. Then select column B, do a Copy and then Paste Special, Value.

quot;Rizaquot; wrote:

gt; I have like 5000 different data and I need to add letter ab in front of them.
gt; Could anyone tell me how to do this.
gt;
gt; for example 123 is what it says but I need ab123 and each row is different
gt; number.

Assuming all the numbers are in Col A, and are on consecutive rows, in Col B
write =?b??amp;A1. Then highlite your whole Col B range, copy, paste special
values. Move it to Col A and you?e done.

quot;Rizaquot; wrote:

gt; I have like 5000 different data and I need to add letter ab in front of them.
gt; Could anyone tell me how to do this.
gt;
gt; for example 123 is what it says but I need ab123 and each row is different
gt; number.

If you want a space then =quot;abquot;amp;quot; quot;amp;A2

HTH
Regards,
Howard

quot;Rizaquot; gt; wrote in message
news
gt;I have like 5000 different data and I need to add letter ab in front of
gt;them.
gt; Could anyone tell me how to do this.
gt;
gt; for example 123 is what it says but I need ab123 and each row is different
gt; number.
Say A2 is the start of the column of dataPut this routine in a Module in VB Editor (Tools gt; Macro gt; Vb Editor )
Toolbar gt;insert gt; Module

Module1 shows in the projects window

copy and paste this macro into it
Close the vBeditor then
On the sheet toolbar Run macroSub AddABToData()
Dim strcell, strAB as string
strAB=quot;ABquot;
range(quot;A2quot;) .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.valuelt;gt;quot;quot; then
strCell=strAB amp; cell.value
cell.value=strCell
end if
next

end sub

- -markquot;Rizaquot; wrote:

gt; I have like 5000 different data and I need to add letter ab in front of them.
gt; Could anyone tell me how to do this.
gt;
gt; for example 123 is what it says but I need ab123 and each row is different
gt; number.

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

quot;exceluserforemanquot; wrote:

gt; Say A2 is the start of the column of data
gt;
gt;
gt; Put this routine in a Module in VB Editor (Tools gt; Macro gt; Vb Editor )
gt; Toolbar gt;insert gt; Module
gt;
gt; Module1 shows in the projects window
gt;
gt; copy and paste this macro into it
gt;
gt;
gt;
gt; Close the vBeditor then
gt; On the sheet toolbar Run macro
gt;
gt;
gt; Sub AddABToData()
gt; Dim strcell, strAB as string
gt; strAB=quot;ABquot;
gt; range(quot;A2quot;) .select
gt; set a=selection
gt; 'aSSUMES THERE IS MORE THAN ONE FILLED CELL
gt; range(a,a.end(xldown)).select
gt; for each cell in selection
gt; if cell.valuelt;gt;quot;quot; then
gt; strCell=strAB amp; cell.value
gt; cell.value=strCell
gt; end if
gt; next
gt;
gt; end sub
gt;
gt; - -mark
gt;
gt;
gt; quot;Rizaquot; wrote:
gt;
gt; gt; I have like 5000 different data and I need to add letter ab in front of them.
gt; gt; Could anyone tell me how to do this.
gt; gt;
gt; gt; for example 123 is what it says but I need ab123 and each row is different
gt; gt; number.