Display Only Last 4 Characters If A Cell

  • Thread starter Thread starter Minitman
  • Start date Start date
M

Minitman

Greetings,

I need to truncate all but the last 4 characters on a cell so that I
can combine those 4 characters with others to create a reference cell.

Anyone have any ideas as to how?

TIA

-Minitman
 
One way:

A1: display
B1: characters
C1: =RIGHT(A1,4) & LEFT(B1,4) ===> playchar
 
Hey JE,

Thanks for the fast reply, that is just what I need.

-Minitman
 
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

Macro that will insert a simple text string in top cell of text file 1
Retrieving Part of a Cell Contents 6
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How Many Characters In A Formula? 5
Paste With A Custom Format 2
Test if Last Character in Column of Cells is Alpha Character 6
How Do I Check To See Id A Character Is Present In A Cell 4
Change color of characters in a cell based of a cell reference 2

Back
Top