Hi
using a helper cell in column B:
="AB"&A1
--
Regards
Frank Kabel
Frankfurt, Germany
"ramsdesk" schrieb im
Newsbeitrag ...
I have a column with lots of rows having different numbers in it. I
need
a add a string to each of the cell before the number.
For example:
Col A
1234
2345
3456
4567
String to be added = 'AB'
Result:
Col A
AB1234
AB2345
AB3456
AB4567
Any help please.... TIA.
--
ramsdesk
---------------------------------------------------------------------
---
ramsdesk's Profile:
http://www.excelforum.com/member.php...o&userid=15705
View this thread:
http://www.excelforum.com/showthread...hreadid=273074