Extract char from multicells to build new in another

  • Thread starter Thread starter Kat
  • Start date Start date
K

Kat

In column A, i need to build a new char string where the
first three char come from column B, then a dash is
added, and the first 16 char from column C. I couldn't
get the recorder to do this for me.

Example

Column A | Column B | Column C
App-Mushrooms, Stuffed | Appetizer | Mushrooms, Stuffed
Portabello
 
In A1:
=left(B1,3) & "-" & left(c1,16)

or in VBA

sStr = left(Range("B1"),3) & "-" & left(Range("c1"),16)
Range("A1").Value = sStr
 
Thank you Tom! We used the formula & it worked.
-----Original Message-----
In A1:
=left(B1,3) & "-" & left(c1,16)

or in VBA

sStr = left(Range("B1"),3) & "-" & left(Range("c1"),16)
Range("A1").Value = sStr

--
Regards,
Tom Ogilvy




.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extracting chars from strings (Visual Basic) 3
extracting a single char from a string of chars 2
automation to remove certain characters from a cell 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Extract text strings from xls cells containing outlook items 3
How to find multiple same char in a string in Excel? 3
Char(1) can't be insert from stored procedure called from C#/ASP.n 2
extract char x to char y of a cell 4

Back
Top