hey everyone i am new
i have a spreadsheet with a 2 columns with numbers in column and names in column c
Sample
A
1393
1412
1423
65700
after the replace
c
187-1393
187-1412
187-1423
187-65700
basically taking what ever in column a placing "187-" in front of it
Last edited by darknight40; 06-24-2011 at 10:24 PM.
Use this formula, copied down the column.
="187-"&A1
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thank you that was easy ... thanks alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks