Hello,
I have a string of numbers ex. 1234, 5678, 91011 in 400 rows. Before each string I would like to add 88.
How can I do this?
Thank you.
Brandy
Hello,
I have a string of numbers ex. 1234, 5678, 91011 in 400 rows. Before each string I would like to add 88.
How can I do this?
Thank you.
Brandy
Last edited by Brandy; 01-07-2009 at 12:00 PM.
="88"&A1
or whatever the column/cell is
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hello Brandy,
Assume your data in a1 row so use following formula.
=CONCATENATE(88,A1)
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Hi, Try:-
Regards MickPlease Login or Register to view this content.
Excellent!
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks