I have a cell that has text followed by numbers. Ex: Bob 1234
I need to add [brackets] to only the numbers. What formula can I write to do this?
Thanks!
I have a cell that has text followed by numbers. Ex: Bob 1234
I need to add [brackets] to only the numbers. What formula can I write to do this?
Thanks!
Separate the Name and the numbers in 2 separate columns using Data tab --> Text to Columns --> Delimited --> Specae option and then apply the following formula in an adjacent column
where M & N represents your separated values (e.g. M contains Bob and N contains the numbersFormula:Please Login or Register to view this content.
Liked the answer given? click * to say so
thank you. I forgot about separating the text from numbers!!!
Assuming Bob 1234 is in cell A1
in B1
copy and paste
=TRIM(LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1))
in C1
See post below.
Last edited by AlKey; 11-21-2013 at 02:48 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Actually for C1 this would be better
="["&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),25)&"]"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks