change a cell with a letter and string of numbers to a word and a string of numbers

**dlamin130** · 08-23-2012, 04:44 PM

I am trying to convert all the data in a particular column to "<word> <letter> <numbers>". Some are "<word> <letter>", some are "<letter> <numbers>". Is there a formual that will auto add in these fields to every cell? I have attached a file to demonstrate further what I mean. Thanks in advance! Book1.xls

**shg** · 08-23-2012, 04:55 PM

Select the column and replace "a* " sans quotes with "company a " sans quotes.

**Ace_XL** · 08-23-2012, 04:58 PM

How about..

="company "&LEFT(A2,1)&" "&RIGHT(A2,LEN(A2)-FIND(" ",A2))
or
="company "&LEFT(A2,1)&" "&LOOKUP(99^99,--("0"&MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW($1:$10000))))

change a cell with a letter and string of numbers to a word and a string of numbers

LinkBack

Thread Tools

Rate This Thread

Display

change a cell with a letter and string of numbers to a word and a string of numbers

Re: change a cell with a letter and string of numbers to a word and a string of numbers

Re: change a cell with a letter and string of numbers to a word and a string of numbers

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions